﻿<!--{inc(header.view.html)}-->

<div class="header">    
  
                       <div class="nav">
	                                 <ul id="nav_list">
                                     

                                                 <li><a href="index.php?app=database&act=filedadd&id={$id}"  target="mainframe">字段添加</a></li>
                                                 <li><a href="index.php?app=database&act=filedlist&id={$id}"  target="mainframe">字段列表</a></li>				 
                                                 <li><a href="index.php?app=database&act=createtable"  target="mainframe">数据库表列表</a></li>


	                                 </ul>
                       </div>
                
</div>



<div id="content">
                   <h1>字段修改</h1>

                  <div>
                                    <div class="tips_show"><img  src="{$web_view_dir}style/images/light.gif" align="absmiddle" /> <b>提示: </b>
                                                                  <span > </span>
                                    </div>


                                 
                                 

<form action="?app=database&act=filedpostedit" method="post" >

<table width="100%" cellspacing="0" cellpadding="4" border="0" align="center"  class="table_style">
<tbody> 


<tr>
	<td>字段中文名:</td>
	<td><input type="text" maxlength="20"  size="30" name="data[filed][cname]" value="{$data.filed.cname}"></td>
</tr>

<tr>
	<td>提示信息:</td>
	<td><input type="text" maxlength="20"  size="30" name="data[tips]" value="{$data.tips}"></td>
</tr>


 <tr>
	<td width="30%">数据库字段名</td>
	<td><input type="text" maxlength="50" size="50" value="{$data.filed.name}" name="data[filed][name]"></td>
</tr>

<tr>
	<td>数据库字段数据类型:</td>
	<td>  <select name="data[filed][type]"  onChange="field_choose(this.options[this.selectedIndex].value)">
	           <?php if ($data.filed.type) { ?>
                <option value="{$data.filed.type}" selected="selected">{$data.filed.type}</option>
				<?php } ?>	
                <option value="varchar">varchar</option>
                <option value="tinyint">tinyint</option>
                <option value="text">text</option>
                <option value="data">data</option>
                <option value="smallint">smallint</option>
                <option value="mediumint">mediumint</option>
                <option value="int">int</option>
                <option value="bigint">bigint</option>
                <option value="float">float</option>
                <option value="double">double</option>
                <option value="decimal">decimal</option>
                <option value="datetime">datetime</option>
                <option value="timestamp">timestamp</option>
                <option value="time">time</option>
                <option value="year">year</option>
                <option value="char">char</option>
                <option value="tinyblob">tinyblob</option>
                <option value="tinytext">tinytext</option>
                <option value="blob">blob</option>
                <option value="mediumblob">mediumblob</option>
                <option value="mediumtext">mediumtext</option>
                <option value="longblob">longblob</option>
                <option value="longtext">longtext</option>
                <option value="enum">enum</option>
                <option value="set">set</option>
                <option value="bool">bool</option>
                <option value="binary">binary</option>
                <option value="varbinary">varbinary</option>
        </select>		
		
</td>
</tr>

<tr>
	<td>数据库字段长度:</td>
	<td><input type="text" maxlength="20"  size="8" name="data[filed][length]" value="{$data.filed.length}"></td>
</tr>

<tr>
	<td>数据库字段是否为null:</td>
	<td>
	<select name="data[filed][isnull]" >
    <option value="NOT NULL" <?php if ($data.filed.isnull == 'NOT NULL') { ?> selected="selected" <?php } ?> >not null</option>
    <option value="" <?php if ($data.filed.isnull == '') { ?> selected="selected"  <?php } ?>  >null</option>
	           
 
    </select>
</td>
</tr>

<tr>
	<td>数据库字段的默认值:</td>
	<td>
	<input  type="text" name="data[filed][defaultv]" size="12" value="{$data.filed.defaultv}" />
</td>
</tr>


<tr>
	<td>&nbsp;</td>
	<td><input name="tbid" type="hidden" value="{$tbid}" /><input name="id" type="hidden" value="{$id}" /><input name="data[tablev]" type="hidden" value="{$id}" /><input type="submit" value=" 提 交 " class="buton"></td>
</tr>
</tbody></table>
</form>                                 
                                 

                                           
                                 
                                 

                 </div>

</div>



<!--{inc(footer.view.html)}-->